
CREATE INDEX "ix_QualityControl" ON "QualityControlLevelsCache" ("QualityControlLevelCode" ASC, "Definition" ASC);
CREATE INDEX "ix_dataSeries" ON "DataSeriesCache" ("SiteID" ASC, "VariableID" ASC, "MethodID" ASC, "SourceID" ASC, "QualityControlLevelID" ASC, "ServiceID" ASC);
CREATE UNIQUE INDEX "ix_dataSeriesId" ON "DataSeriesCache" ("SeriesID" ASC);
CREATE INDEX "ix_dataService" ON "DataServices" ("ServiceEndpointURL" ASC);
CREATE UNIQUE INDEX "ix_dataServices" ON "DataServices" ("ServiceID" ASC);
CREATE INDEX "ix_isoMd" ON "ISOMetadataCache" ("MetadataLink" ASC);
CREATE UNIQUE INDEX "ix_isoMdId" ON "ISOMetadataCache" ("MetadataID" ASC);
CREATE UNIQUE INDEX "ix_methodId" ON "MethodsCache" ("MethodID" ASC);
CREATE INDEX "ix_methods" ON "MethodsCache" ("MethodDescription" ASC, "MethodLink" ASC);
CREATE UNIQUE INDEX "ix_qualityControlId" ON "QualityControlLevelsCache" ("QualityControlLevelID" ASC);
CREATE INDEX "ix_sites" ON "SitesCache" ("SiteCode" ASC);
CREATE UNIQUE INDEX "ix_sitesId" ON "SitesCache" ("SiteID" ASC);
CREATE INDEX "ix_sources" ON "SourcesCache" ("Organization" ASC);
CREATE UNIQUE INDEX "ix_sourcesId" ON "SourcesCache" ("SourceID" ASC);
CREATE INDEX "ix_variables" ON "variablesCache" ("VariableCode" ASC);
CREATE UNIQUE INDEX "ix_variablesId" ON "variablesCache" ("VariableID" ASC);

